<%@ page import="java.sql.*"%> <%
 	String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
         
	String pr=request.getParameter("prjid");
	String va=request.getParameter("valid");
	try
 	{
 		Class.forName(driver);

 		Connection connection = DriverManager.getConnection(
 				"jdbc:odbc:SPMS", "", "");

 		Statement statement = connection.createStatement();

 		String query = "UPDATE Project SET validated = '"+va+"'WHERE ID ="+pr;
 		// Execute query and save results.
 		ResultSet res = statement.executeQuery(query);
	} catch (ClassNotFoundException cnfe)
	{
		out.println("No such class: " + driver);
	} catch (SQLException se)
	{
		out.println("SQLException: " + se);
	} 
%>
